منابع مشابه
Mining SQL Execution Traces for Data Manipulation Behavior Recovery
Modern data-intensive software systems manipulate an increasing amount of heterogeneous data in order to support users in various execution contexts. Maintaining and evolving activities of such systems rely on an accurate documentation of their behavior which is often missing or outdated. Unfortunately, standard program analysis techniques are not always suitable for extracting the behavior of ...
متن کاملCreating a Data Warehouse using SQL Server
In this paper we construct a Star Join Schema and show how this schema can be created using the basic tools delivered with SQL Server 7.0. Major objectives are to keep the operational database unchanged so that data loading can be done without disturbing the business logic of the operational database. The operational database is an expanded version of the Pubs database [Sol96].
متن کاملSQL Memory Management in Oracle9i
Complex database queries require the use of memory-intensive operators like sort and hashjoin. Those operators need memory, also referred to as SQL memory, to process their input data. For example, a sort operator uses a work area to perform the in-memory sort of a set of rows. The amount of memory allocated by these operators greatly affects their performance. However, there is only a finite a...
متن کاملData Exploration with SQL using Machine Learning Techniques
Nowadays data scientists have access to gigantic data, many of them being accessible through SQL. Despite the inherent simplicity of SQL, writing relevant and efficient SQL queries is known to be difficult, especially for databases having a large number of attributes or meaningless attribute names. In this paper, we propose a “rewriting” technique to help data scientists formulate SQL queries, ...
متن کاملMining Medical Data using SQL Queries and Contingency Tables
This work presents the data mining effort to retrieve meaningful information from a Medical Database collected at the Chiba University Hospital, Japan for patients suffering from Collagen diseases. The data, after being examined and cleaned [1,2], was transformed and loaded into a Relational Database. SQL queries have been used to retrieve data in the form of contingency table, which is further...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: The Journal of the Korea Contents Association
سال: 2011
ISSN: 1598-4877
DOI: 10.5392/jkca.2011.11.12.597